from django.db import models


# Create your models here.
class Classroombasicinfo(models.Model):
    building_id = models.IntegerField()
    cid = models.IntegerField()
    classroom_name = models.IntegerField()
    capacity = models.IntegerField()
    notice = models.CharField(max_length=45, blank=True, null=True)
    attribute = models.CharField(max_length=45)

    class Meta:
        managed = False
        db_table = 'classroombasicinfo'


class Facility(models.Model):
    fid = models.AutoField(primary_key=True)
    building_id = models.IntegerField()
    cid = models.IntegerField()
    category = models.CharField(max_length=45)
    f_name = models.CharField(max_length=45)
    f_num = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'facility'


class Building(models.Model):
    building_id = models.IntegerField(primary_key=True)
    building_name = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'building'
